-- lzfy_refund_dict表数据插入语句
-- 忽略id和input_date字段，这些字段会自动生成

USE [refunddb]
GO

-- 附件类型 (dict_id = 1)
INSERT INTO [dbo].[lzfy_refund_dict] ([dict_id], [dict_name], [item_name], [item_value])
VALUES (1, '附件类型', '本人证件', '1');

INSERT INTO [dbo].[lzfy_refund_dict] ([dict_id], [dict_name], [item_name], [item_value])
VALUES (1, '附件类型', '代办人证件', '2');

INSERT INTO [dbo].[lzfy_refund_dict] ([dict_id], [dict_name], [item_name], [item_value])
VALUES (1, '附件类型', '关系证明', '3');

-- 退款类型 (dict_id = 2)
INSERT INTO [dbo].[lzfy_refund_dict] ([dict_id], [dict_name], [item_name], [item_value])
VALUES (2, '退款类型', '本人退款', '1');

INSERT INTO [dbo].[lzfy_refund_dict] ([dict_id], [dict_name], [item_name], [item_value])
VALUES (2, '退款类型', '代办人退款', '2');

-- 审核类型 (dict_id = 3)
INSERT INTO [dbo].[lzfy_refund_dict] ([dict_id], [dict_name], [item_name], [item_value])
VALUES (3, '审核类型', '审核通过', '1');

INSERT INTO [dbo].[lzfy_refund_dict] ([dict_id], [dict_name], [item_name], [item_value])
VALUES (3, '审核类型', '审核失败', '2');

-- 与患者关系 (dict_id = 4)
INSERT INTO [dbo].[lzfy_refund_dict] ([dict_id], [dict_name], [item_name], [item_value])
VALUES (4, '与患者关系', '本人', '1');

INSERT INTO [dbo].[lzfy_refund_dict] ([dict_id], [dict_name], [item_name], [item_value])
VALUES (4, '与患者关系', '配偶', '2');

INSERT INTO [dbo].[lzfy_refund_dict] ([dict_id], [dict_name], [item_name], [item_value])
VALUES (4, '与患者关系', '父亲', '3');

INSERT INTO [dbo].[lzfy_refund_dict] ([dict_id], [dict_name], [item_name], [item_value])
VALUES (4, '与患者关系', '母亲', '4');

INSERT INTO [dbo].[lzfy_refund_dict] ([dict_id], [dict_name], [item_name], [item_value])
VALUES (4, '与患者关系', '儿子', '5');

INSERT INTO [dbo].[lzfy_refund_dict] ([dict_id], [dict_name], [item_name], [item_value])
VALUES (4, '与患者关系', '女儿', '6');

INSERT INTO [dbo].[lzfy_refund_dict] ([dict_id], [dict_name], [item_name], [item_value])
VALUES (4, '与患者关系', '祖父', '7');

INSERT INTO [dbo].[lzfy_refund_dict] ([dict_id], [dict_name], [item_name], [item_value])
VALUES (4, '与患者关系', '祖母', '8');

INSERT INTO [dbo].[lzfy_refund_dict] ([dict_id], [dict_name], [item_name], [item_value])
VALUES (4, '与患者关系', '孙子', '9');

INSERT INTO [dbo].[lzfy_refund_dict] ([dict_id], [dict_name], [item_name], [item_value])
VALUES (4, '与患者关系', '孙女', '10');

INSERT INTO [dbo].[lzfy_refund_dict] ([dict_id], [dict_name], [item_name], [item_value])
VALUES (4, '与患者关系', '兄弟', '11');

INSERT INTO [dbo].[lzfy_refund_dict] ([dict_id], [dict_name], [item_name], [item_value])
VALUES (4, '与患者关系', '姐妹', '12');

INSERT INTO [dbo].[lzfy_refund_dict] ([dict_id], [dict_name], [item_name], [item_value])
VALUES (4, '与患者关系', '其他', '13');

-- 审核备注 (dict_id = 5)
INSERT INTO [dbo].[lzfy_refund_dict] ([dict_id], [dict_name], [item_name], [item_value])
VALUES (5, '审核备注', '审核通过', '1');

INSERT INTO [dbo].[lzfy_refund_dict] ([dict_id], [dict_name], [item_name], [item_value])
VALUES (5, '审核备注', '审批不通过,资料不全', '2');

GO